OVERHAUL PART 1 COMPLETE!!!The first part of my overhaul is complete. With this overhaul, I'm also changing how I manage permissions. Each purchaser will receive access to a folder with my master copy in it, but WILL NOT be able to edit the sheet. You must make a copy of this for your own use. When a change is made, a notification will be sent to your gmail. Just open the folder and copy the new version. This will help keep everyone up-to-date.
These 6 spreadsheets are ready to go:
GÇóTech 1 Ships
GÇóTech 1 Ammo
GÇóTech 1 Drones
GÇóTech 1 Rigs
GÇóAdvanced Market Trading
GÇóOre Compression (GDocs-manual integration)
A LOT of new features have been added to these sheets (mostly the industry ones). The price is NOT INCREASING. Prices can be found on the 1st post in this thread. Adv. Market Trading is being reduced from 200 to 150M, and the basic version has been discontinued.
Click Here to view screenshots of the overhauled spreadsheets.The new features on the manufacturing sheets are:1) Full instructions on a new tab.
2) All general inputs have been moved to a new Setup tab.
3) Setup tabs include areas to input:
GÇóCustom price that overrides market price for each item.
GÇóAbility to specify the system that market data comes from.
GÇóInputs for trading skills and reputation to calculate sales tax.
4) Unified Blueprint Data tab, sectioned off based on type of item.
GÇóEnter ME & TE of each blueprint here.
5) Market Comparison tab
GÇóType in system names to pull prices from.
GÇóSelect price type for each system.
GÇóSheet used build cost from Blueprint Data tab to calculate profit
GÇóProfit includes sales tax (based on skills&reputation)
GÇóCalculates profit and margin at each location
GÇóDisplays where cheapest materials are, and where to sell to earn the highest profit
GÇóCalculates average daily sales volume (over the past 14 days).
GÇó"Force Refresh" button will tell the sheet to refresh the imported market data.
6) Production Planner tab:
GÇóSelect a blueprint dropdown lists (up to 50).
GÇóEnter number of runs.
GÇóTab will calculate total build cost, total profit, profit margin, total market price, and build time.
GÇóTab shows materials required to make each item.
GÇóCalculates total materials required to for all blueprints selected.
GÇóCalculates total material cost, total profit and material volume.
GÇóInput current stocks and sheet will calculate remainder, and cost to purchase the remainder.
NEW DISCOUNT PROGRAMAfter using my sheets, post feedback here and get 10% of your payment returned to you!